package com.jwsoft.manager.core.dao.mapper;

import com.jwsoft.manager.common.vo.bigScreen.analysisXq.*;
import com.jwsoft.manager.common.vo.dataStatistics.school.SchoolEnrollCntVO;
import com.jwsoft.manager.common.vo.dataStatistics.school.SchoolEnrollQueryVO;
import com.jwsoft.manager.common.vo.dataStatistics.school.SchoolEnrollVO;
import com.jwsoft.manager.common.vo.eduSchool.EduSchoolQueryVO;
import com.jwsoft.manager.common.vo.eduSchool.EduSchoolVO;
import com.jwsoft.manager.common.vo.eduSchoolConfig.EduSchoolConfigVO;
import com.jwsoft.manager.core.dao.model.EduSchool;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jwsoft.manager.core.dao.model.EduSchoolConfig;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

/**
* <p>
  * 所属学校表 Mapper 接口
  * </p>
*
* @author wangtao
* @since 2022-11-25
*/
@Mapper
public interface EduSchoolMapper extends BaseMapper<EduSchool> {
    List<EduSchoolVO> selectSchoolList(Map<String,Object> record);

    List<EduSchoolVO> querySchoolStaInfo(Map<String, Object> record);

    List<EduSchoolVO> querySchoolStaInfoHistory(Map<String, Object> record);

    //报名总人数
    List<SchoolEnrollCntVO> queryApplyNum(SchoolEnrollQueryVO vo);

    //报名有效总人数
    List<SchoolEnrollCntVO> queryApplyYxNum(SchoolEnrollQueryVO vo);

    //待审核人数
    List<SchoolEnrollCntVO> queryAuditWaitNum(SchoolEnrollQueryVO vo);

    //待录取人数
    List<SchoolEnrollCntVO> queryAuditNum(SchoolEnrollQueryVO vo);

    //已录取
    List<SchoolEnrollCntVO> queryAdmitNum(SchoolEnrollQueryVO vo);

    //已录取 学校录入人数
    List<SchoolEnrollCntVO> queryAdmitXxNum(SchoolEnrollQueryVO vo);

    //调剂调出人数
    List<SchoolEnrollCntVO> queryFromNum(SchoolEnrollQueryVO vo);

    //已录取 调剂调入人数
    List<SchoolEnrollCntVO> queryToNum(SchoolEnrollQueryVO vo);

    //随迁人数
    List<SchoolEnrollCntVO> querySqNum(SchoolEnrollQueryVO vo);

    //非随迁人数
    List<SchoolEnrollCntVO> queryFsqNum(SchoolEnrollQueryVO vo);

    //特殊通道数
    List<SchoolEnrollCntVO> queryTstdNum(SchoolEnrollQueryVO vo);

    //补报数
    List<SchoolEnrollCntVO> queryBbNum(SchoolEnrollQueryVO vo);

    //抢报数
    List<SchoolEnrollCntVO> queryQbNum(SchoolEnrollQueryVO vo);

    //报名总人数
    List<SchoolEnrollCntVO> queryApplyNumHistory(SchoolEnrollQueryVO vo);

    //报名有效总人数
    List<SchoolEnrollCntVO> queryApplyYxNumHistory(SchoolEnrollQueryVO vo);

    //待审核人数
    List<SchoolEnrollCntVO> queryAuditWaitNumHistory(SchoolEnrollQueryVO vo);

    //待录取人数
    List<SchoolEnrollCntVO> queryAuditNumHistory(SchoolEnrollQueryVO vo);

    //已录取
    List<SchoolEnrollCntVO> queryAdmitNumHistory(SchoolEnrollQueryVO vo);

    //已录取 学校录入人数
    List<SchoolEnrollCntVO> queryAdmitXxNumHistory(SchoolEnrollQueryVO vo);

    //调剂调出人数
    List<SchoolEnrollCntVO> queryFromNumHistory(SchoolEnrollQueryVO vo);

    //已录取 调剂调入人数
    List<SchoolEnrollCntVO> queryToNumHistory(SchoolEnrollQueryVO vo);

    //随迁人数
    List<SchoolEnrollCntVO> querySqNumHistory(SchoolEnrollQueryVO vo);

    //非随迁人数
    List<SchoolEnrollCntVO> queryFsqNumHistory(SchoolEnrollQueryVO vo);

    //特殊通道数
    List<SchoolEnrollCntVO> queryTstdNumHistory(SchoolEnrollQueryVO vo);

    //补报数
    List<SchoolEnrollCntVO> queryBbNumHistory(SchoolEnrollQueryVO vo);

    //抢报数
    List<SchoolEnrollCntVO> queryQbNumHistory(SchoolEnrollQueryVO vo);

    //幼儿园报名有效总人数
    List<SchoolEnrollCntVO> queryYeyApplyNum(SchoolEnrollQueryVO vo);

    //幼儿园待审核人数
    List<SchoolEnrollCntVO> queryYeyAuditWaitNum(SchoolEnrollQueryVO vo);

    //幼儿园待录取人数
    List<SchoolEnrollCntVO> queryYeyAuditNum(SchoolEnrollQueryVO vo);

    //幼儿园已录取人数
    List<SchoolEnrollCntVO> queryYeyAdmitNum(SchoolEnrollQueryVO vo);

    //义务段根据报名类别统计数据
    List<SchoolEnrollVO> queryBmByLb(SchoolEnrollQueryVO vo);

    List<SchoolEnrollVO> queryBmByLbHistory(SchoolEnrollQueryVO vo);

    List<SchoolEnrollVO> queryRegistStatistics(Map<String, Object> record);

    List<AreaXwpmVO> getAreaXwpmVO(SchoolOverviewXqQueryVO vo);
    List<SchoolXwpmVO> getSchoolXwpmVO(SchoolXwpmQueryVO vo);
    SchoolXqVO getSchoolXqVO(SchoolXqQueryVO vo);
    List<SchoolXqVO> getSchoolXqVOList(SchoolXqQueryVO vo);

    List<SchoolEnrollCntVO> queryYeyApplyNumHistory(SchoolEnrollQueryVO vo);

    List<SchoolEnrollCntVO> queryYeyAuditWaitNumHistory(SchoolEnrollQueryVO vo);

    List<SchoolEnrollCntVO> queryYeyAuditNumHistory(SchoolEnrollQueryVO vo);

    List<SchoolEnrollCntVO> queryYeyAdmitNumHistory(SchoolEnrollQueryVO vo);

}
